﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="detail.aspx.cs" Inherits="参保_detail" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>参保缴费信息</title>
        <LINK href="../Css/style.css" type="text/css" rel="stylesheet"/>
        
        
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:HyperLink ID="HyperLink1" runat="server">返回用户列表</asp:HyperLink><br />
        <br />
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4"
            DataKeyNames="personId" DataSourceID="SqlDataSource2" ForeColor="#333333">
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <Columns>
                <asp:BoundField DataField="personId" HeaderText="身份证号" ReadOnly="True" SortExpression="personId" />
                <asp:BoundField DataField="insuranceId" HeaderText="个人编号" SortExpression="insuranceId" />
                <asp:BoundField DataField="username" HeaderText="姓名" SortExpression="username" />
                <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />
                <asp:BoundField DataField="gsdw" HeaderText="归属单位" SortExpression="gsdw" />
                <asp:BoundField DataField="phone" HeaderText="电话" SortExpression="phone" />
                <asp:BoundField DataField="cbzt" HeaderText="参保状态" SortExpression="cbzt" />
            </Columns>
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <EmptyDataTemplate>
                无数据
            </EmptyDataTemplate>
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#999999" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:insurance_dbConnectionString %>"
            SelectCommand="SELECT DISTINCT * FROM [缴费人员表] WHERE ([personId] = @personId)">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="0" Name="personId" QueryStringField="personId"
                    Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <br />
        共<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>条记录，每页10条记录<br />
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="id" DataSourceID="SqlDataSource1"
            ForeColor="#333333">
            <PagerSettings Mode="NumericFirstLast" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <Columns>
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
                    SortExpression="id" />
                <asp:BoundField DataField="personId" HeaderText="身份证号" SortExpression="personId" />
                <asp:BoundField DataField="insuranceId" HeaderText="个人编号" SortExpression="insuranceId" />
                <asp:BoundField DataField="code" HeaderText="资金帐号" SortExpression="code" />
                <asp:BoundField DataField="jfsj" DataFormatString="{0:yyyy-MM}" HeaderText="缴费时间"
                    SortExpression="jfsj" />
                <asp:BoundField DataField="xz" HeaderText="险种" SortExpression="xz" />
                <asp:BoundField DataField="jfgz" HeaderText="缴费工资" SortExpression="jfgz" />
                <asp:BoundField DataField="jfbl" HeaderText="缴费比例" SortExpression="jfbl" />
                <asp:BoundField DataField="jsbl" HeaderText="计算比例" SortExpression="jsbl" />
                <asp:BoundField DataField="jsfs" HeaderText="计算方式" SortExpression="jsfs" />
                <asp:BoundField DataField="jfje" HeaderText="缴费金额" SortExpression="jfje" />
                <asp:BoundField DataField="del" HeaderText="删除标记" SortExpression="del" />
            </Columns>
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <EmptyDataTemplate>
                没有数据
            </EmptyDataTemplate>
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#999999" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:insurance_dbConnectionString %>"
            SelectCommand="SELECT * FROM [缴费表] WHERE ([personId] = @personId) ORDER BY [jfsj] DESC, [xz]" OnSelected="SqlDataSource1_Selected">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="0" Name="personId" QueryStringField="personId"
                    Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>
